While we haven't yet figured out how to do complete Amortizations in FileMakerPro, this is a fair effort at a payment record for a loan. If anyone has any comments or ideas, please forward them to our address o
Al's drive
Al's drive
7/18/91
ACCTNO
BUSINESS PHONE
CONSTANT
DUE DAY
FNAME
GRACE PERIOD
HOME PHONE
INTEREST
LNAME
OVERSYMBOL
PAYMENT CALC
PAYMENT EXPECTED
PAYMENT MADE
PAYMENT TO INTEREST
PAYMENT TO PRINCIPLE
PENALTY
PERIOD
PMTDATE
PMTNO
PRINCIPLE
PRINCIPLE REMAINING TO DATE
QTYPAYMENTS
REMAINING PRINCIPLE
SBUSINESS PHONE
SERVICE CHARGE
SFNAME
SLNAME
STATE
STREET
TOTAL INTEREST PAID
TOTAL PRINCIPLE PAID
XXINTTO DATE
XXPRINCTO DATE
AcctNoB
FNameB
LNameB
StreetB
CityB
StateB
Home PhoneB
Business PhoneB
SFNameB
SLNameB
SBusiness PhoneB
RaceB
A*Black
Hispanic
Oriental
White
Native
Other
ConstantB
InterestB
PeriodB
A PrincipleB
Payment ExpectedB
A*Round(PMT(Principle,Interest/12,Period),2)
PMTNoB
PMTDateB
Payment Made
QtyPaymentsB
Count (Payment Made)
ayment CalcB
QtyPayments + Constant
Principle Remaining to DateB
iS@H5
Amortization Payment Record
Payment to InterestB
AJIf(Payment Made=0,"0.00",Principle Remaining to Date*Extend (Interest)/12)
Payment to PrincipleB
A"Payment Made - Payment to Interest
Total Principle PaidB
A2Round(Constant - 1 + Sum (Payment to Principle),2)
Total Interest PaidB
A,Round(Constant-1+Sum(Payment to Interest),2)
Remaining PrincipleB
A'Round(Principle-Total Principle Paid,2)
xxintto dateB
Sum (Payment to Interest)
xxPrincto dateB
Sum(Payment to Principle)
OVERSYMBOLB
ArIf(Payment Made < Extend (Payment Expected), "Under",If(Payment Made > Extend (Payment Expected), "Over","") )
AJIf(Payment Made=0,"0.00",Principle Remaining to Date*Extend (Interest)/12)
Payment to PrincipleB
A"Payment Made - Payment to Interest
Total Interest PaidB
A,Round(Constant-1+Sum(Payment to Interest),2)
Remaining PrincipleB
A'Round(Principle-Total Principle Paid,2)
xxintto dateB
Sum (Payment to Interest)
xxPrincto dateB
Sum(Payment to Principle)
es of records
3. Calculations of overpayment/underpayment on loan retirement.
Developed by:
Dawn M. Poskin & David E. Heady
Macintosh Professional Consultants
417 North Main Street
Crown Point, IN 46307
-662-0052
Fax 219-662-7572
shed. Till then you may leave your name and address and we will contact you with pricing when the time comes.
Because of its commercial applications and the beta nature of
Overpayment/underpay
Payment
Payments
Period
Place
Please
Pmtdate
Point
Poskin
Pricing
Principle
Print
Produce
Product
Professional
Progress
Record
Records
Reference
Remaining
Resulting
Venture
Version
While
Decimal
Developed
Directions
Effort
Enough
Enter
Entered
Expected
Features
Figure
Figured
Filemakerpro
Final
Finished
Forward
Future
Germane
Haven't
Heady
Ideas
Information
Interest
Interested
Iterations
Months
Nature
Order
to PMtDate and enter date.
5. Tab to PMT Made and enter the amount paid. This should match the Payment Expected. If it is more, more is applied to principle and an "Over" appears to the left. If it is less, "UG
nder" appears. If you have not paid enough to cover the interest, the Prin Pmt becomes a negative and Interest is added to your Running Balance.
We have developed this as a commercial venture. This a beta version, i.e., work in progress. If you are interested in the final product you may place an order and we will send you complete directions aC
nd a disk copy as soon as we are finished. Till then you may leave your name and address and we will contact you with pricing when the time comes.
Because of its commercial applications and the beta nature of
the work this copy is crippled to produce only ten iterations of payments and it will not print.
1. To use, enter all germane data in top section .
2. Enter Loan Information. Period is the length of time of thE
e loan in months. Interest must be entered as a decimal.
3. Enter the resulting figure calculated, i.e., Balance Reference (this is also Remaining Balance) into the top line of Running Balance.
4. Tab through
56900R
511.94T
9/1/91
10/1/91
11/1/91
12/1/91U
511.94
510.00
250.50
1250.00V
56900
56814.81
56730.92
56905.90
56082.70Z
426.75
426.111075
425.4819
426.79425[
85.19
83.888925
-174.9819
823.20575\
817.3]
1705.14^
56082.7_
1705.137225`
817.302775
Under
Under
Overb
358.358e
358.358
John C
SmithD
1234 Main StreetE
HammondF
46324H
219-555-8978I
219-555-7896J
JaneK
SmithL
219-555-9871
While we haven't yet figured out how to do complete Amortizations in FileMakerPro, this is a fair effort at a payment record for a loan. If anyone has any comments or ideas, please forward them to our address o
(.txt)